package db;

import model.Item;
import model.Project;
import model.ProjectUsedItem;

import java.sql.SQLException;
import java.util.ArrayList;

public interface IFProjectUsedItem
{
	public int addProjectUsedItem(Project project, Item item, int quantity) throws SQLException;
	public int deleteProjectUsedItem(Project project, int itemID) throws SQLException;
	public int updateProjectUsedItem(Project project, int itemID, int quantity) throws SQLException;

	public ArrayList<ProjectUsedItem> getAllProjectUsedItem(Project project) throws SQLException;

	public double getTotalMaterialPrice(int projectID) throws SQLException;
}